Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL
1) Aggregate Functions
2) Analytical Functions
3) Char Functions
4) Constraints
5) Conversion Functions
6) Cursor
7) Data Type
8) Date Timezone
9) Hierarchical Query
10) Index
11) Insert Delete Update
12) Large Objects
13) Numeric Math Functions
14) Object Oriented Database
15) PL SQL
16) Regular Expressions
17) Report Column Page
18) Result Set
19) Select Query
20) Sequence
21) SQL Plus
22) Stored Procedure Function
23) Subquery
24) System Packages
25) System Tables Views
26) Table
27) Table Joins
28) Trigger
29) User Previliege
30) View
31) XML

Conversion Functions
1) Cast null as timestamp
2) Cast string to date type before comparison
3) CAST() convertS one built-in data type (cast) into another
4) Cast(12 98 as number(2))
5) Cast(null as date )
6) COALESCE() returns the first non-null expression in the expression list
7) CONVERSION functions
8) Convert a negative number into one with a trailing minus sign
9) CONVERT() converts between two different character sets The returned values data type is VARCHAR2
10) Converting a Character Formatted as Currency to an Integer Value
11) Converting a Character to an Integer Value
12) Converting VARCHAR2 Percentage Data to a Decimal Equivalent
13) Create a report that shows number of customers per state
14) Decode a column with substr and instr
15) DECODE and GROUPING
16) DECODE and substr function
17) Decode char value to number
18) Decode column data to output more meaningful information
19) Decode for more than one key value pair
20) DECODE in the GROUP BY clause
21) Decode statement could be easily rewritten using the CASE statement
22) Decode the result from row_number over, partition by, order by
23) Demo range comparison with DECODE
24) Errors with the Format Mask
25) Extract any procedure, function or package
26) Format nullable heading
27) NULLIF() compares two expressions If they are equal, it returns NULL Otherwise, it returns the first expression
28) Pass variable into to_char function
29) ROWIDTOCHAR(x)
30) ROWIDTONCHAR(x)
31) Select coalesce( null, , A )
32) Select coalesce( null, sysdate )
33) Select nullif( 1, 1 )
34) Select nullif( 1, null )
35) Syntax
36) The TO_CHAR() function converts the expression into character data
37) To_char(bdate,fmMonth ddth, yyyy)
38) To_char(round(sqrt(sal),2),9999 99)
39) To_char(sysdate, Day, nls_date_language=Dutch)
40) To_char(sysdate,DAY dy Dy) as day, to_char(sysdate,MONTH mon) as month
41) To_char(sysdate,hh24
42) To_number(123)
43) Use chartorowid
44) Use DECODE and SIGN functions on the ORD table
45) Use decode as if statement and output high or low
46) Use Decode as if statement to logic like if then else
47) Use decode create dynamic select statement
48) Use to_char function to init an text value